Spreadsheet Pane Column Definitions

The Spreadsheet pane of the Project view displays a set of standard columns.

Use the Insert Column dialog box and the Edit Column dialog box to change fields in the Spreadsheet pane.

Column	Description	Formula
% Complete	This column displays the manually entered percent complete used to calculate earned value for work packages with a progress technique of Percent Complete.	N/A
% Spent	This column displays the percentage of the forecast spent.	(Actuals / BAC) * 100
Actual Finish	This column displays the actual finish date of the control account or work package.	N/A
Actual Rate	This column displays the actual rate.	Actuals / Actuals Hours
Actual Start	This column displays the actual start date of the control account or work package.	N/A
Actuals	This column displays the total actual currency value of the control account or work package. The Update Totals utility populates the value in the table.	N/A
Apportioned CaWP Uid	This column displays the UID for the work package stored in the Apportioned to field.	N/A
Apportioned to	This column displays the work package to which the budget for the referenced work package is apportioned.	N/A
Assignment % Complete	This column displays the percentage of work that has been completed for the Earned Value class to which the resource is assigned.	N/A
BAC	This column displays the budget at completion or the resource total.	N/A
Baseline Finish	This column displays the baseline finish date that defines the last date of the control account or work package.	N/A
Baseline Start	This column displays the baseline start date that defines the initial status date for the control account or work package.	N/A
Budget	This column displays the total currency budget value of the control account or work package. The Update Totals utility populates the value in the column.	N/A
Budget Rate	This column displays the budget rate.	Budget / Budget Hours
Ca[1-3]Id	This column displays the control account field names.	N/A
Calculated % Complete	This column displays the percentage of the work that has been completed, which is calculated using the formula Earned/BAC * 100. The value in the column is populated when you run the Calculate Progress process or when you manually edit or create the Earned Value class of a resource assignment and run the Update Totals process.	(Earned / BAC) * 100
CAM	This column displays the Control Account Manager (CAM) code attached to the control account.	N/A
CAWPUid	This is used internally by Cobra.	N/A
CI Batch	This is used internally by Cobra.	N/A
Class	This column displays the class associated with the resource.	N/A
Class Description	This column displays a brief description of the class associated with the resource.	N/A
Control Account Codes [1-20]	This column displays the control account codes.	N/A
CPI	This column displays the Cost Performance Index, which is an index of the contract performance.	Earned / Actuals
CPI Performance	This column displays the CPI Performance.	Actuals/ Earned
Current Period Actuals	This column displays the current period actual currency value of the control account or work package. The Update Totals utility populates the value in the table.	N/A
Current Period Budget	This column displays the current period budget value of the control account or work package. The Update Totals utility populates the value in the table.	N/A
Current Period Hours Actuals	This column displays the current period actuals value in hours of the control account or work package. The Update Totals utility populates the value in the table.	N/A
Current Period Hours Budget	This column displays the current period budget value in hours of the control account or work package. The Update Totals utility populates the value in the table.	N/A
Current Period Hours Progress	This column displays the current period earned value in hours of the control account or work package. The Update Totals utility populates the value in the table.	N/A
Current Period Progress	This column displays the current period earned value of the control account or work package. The Update Totals utility populates the value in the table.	N/A
CV	This column displays the Cost Variance in dollars.	Earned - Actuals
CV %	This column displays the Cost Variance percentage.	((Earned - Actuals) / Earned) * 100
Description	This column displays a brief description of the control account or work package.	N/A
EAC	This column displays the total Estimate At Complete currency value based on the cost set EAC. The Update Totals utility populates the value in the table.	N/A
Early Finish	This column displays the early finish date for the control account or work package.	N/A
Early Start	This column displays the early start date for the control account or work package.	N/A
Forecast Finish	This column displays the forecast finish date of the control account or work package.	N/A
Forecast Start	This column displays the initial status date for the control account or work package.	N/A
Hours % Complete	This column displays the percentage of the work that has been completed.	(Earned Hours / BAC Hours) * 100
Hours % Spent	This column displays the percentage of the budget spent.	(Actuals Hours / BAC Hours) * 100
Hours Actuals	This column displays the total actual values in hours.	N/A
Hours BAC	This column displays the budget at completion in hours.	N/A
Hours Budget	This column displays the budget values in hours.	N/A
Hours CPI	This column displays the Cost Performance Index in hours.	Earned Hours / Actuals Hours
Hours CPI Performance	This column displays the CPI Performance in hours.	Actuals Hours/Earned Hours
Hours CV	This column displays the Cost Variance in hours.	Earned Hours - Actuals Hours
Hours CV %	This column displays the Cost Variance percentage.	((Earned Hours - Actuals Hours) / Earned Hours) * 100
Hours EAC	This column displays the total Estimate At Complete currency value in hours.	N/A
Hours iEAC	This column displays the independent Estimate At Complete in hours.	Actuals Hours + ((1 / CPI Hours) * (BAC Hours - Earned Hours))
Hours iEAC2	This column displays the independent Estimate At Complete in hours.	Actuals Hours + ((1 / (CPI Hours * SPI Hours)) * (BAC Hours - Earned Hours))
Hours Progress	This column displays the total earned currency value in hours.	N/A
Hours SPI	This column displays the Schedule Performance Index (SPI) in hours.	Earned Hours / Budget Hours
Hours SV	This column displays the Schedule Variance (SV) in hours.	Earned Hours - Budget Hours
Hours SV %	This column displays the Schedule Variance (SV) percentage.	((Earned Hours - Budget Hours) / Budget Hours) * 100
Hours TCPIBAC	This column displays the To Complete Performance Index for the budget at complete in hours.	(BAC Hours - Earned Hours) / (BAC Hours - Actuals Hours)
Hours TCPIEAC	This column displays the To Complete Performance Index for the projected estimate at complete in hours.	(BAC Hours - Earned Hours) / (EAC Hours - Actuals Hours)
Hours VAC	This column displays the Variance At Complete (VAC) in hours.	BAC Hours - EAC Hours
Hours VAC %	This column displays the Variance At Complete (VAC) percentage.	((BAC Hours - EAC Hours) / BAC Hours) * 100
Hours Variance	This column displays the Variance in hours.	Budget Hours - Actuals Hours
iEAC	This column displays the independent Estimate At Complete.	Actuals + ((1 / CPI) * (BAC - Earned))
iEAC2	This column displays the independent Estimate at Complete.	Actuals + ((1 / (CPI * SPI)) * (BAC - Earned))
Last Update	This column displays the date when the control account or work package details were last updated.	N/A
Late Finish	This column displays the late finish date for the control account or work package.	N/A
Late Start	This column displays the late start date for the control account or work package.	N/A
Non Labor EAC	This column displays the EAC value for resources that do not have an hours result. This field is used in the scale EAC currency option when both hours and currency are selected.	N/A
OP Batch	This is used internally Cobra.	N/A
Pending Finish	This column displays the pending finish date of the control account or work package.	N/A
Pending Start	This column displays the pending start date of the control account or work package.	N/A
Performance Factor	This column displays the performance factor value, usually based on performance to date, which is divided into the budgeted cost of work remaining to arrive at an Estimate To Complete (ETC).	N/A
Progress	This column displays the total earned currency value of the control account or work package. The Update Totals utility populates the value in the table.	N/A
Progress Technique	This column displays the progress technique assigned to the work package.	N/A
Project	This column displays the name of the project.	N/A
Resource	This column displays resource assignment for the selected cost set or class type.	N/A
Resource Assignment Codes [1-9]	This column displays resource assignment codes.	N/A
Resource Description	This column displays a brief description of the resource.	N/A
Sequence	This column is used internally by Cobra.
SPI	This column displays the Schedule Performance Index.	Earned / Budget
Spread Curve	This column displays the spread curve name for the budget or forecast resource assignments. If there is no assigned spread curve, or if the resource assignment is manually spread or adjusted, this column displays Manual. For other types of resource assignments, this column is blank.	N/A
Start Percent	This column displays the opening percent complete for work packages that use the user-defined progress technique.	N/A
Status	This column displays the status of the selected control account or work package.	N/A
SV	This column displays the Schedule Variance in dollars.	Earned - Budget
SV %	This column displays the Schedule Variance percentage.	((Earned - Budget) / Budget) * 100
TCPIBAC	This column displays the To Complete performance index for the budget at complete.	(BAC - Earned) / (BAC - Actuals)
TCPIEAC	This column displays the To Complete Performance Index for the projected estimate at complete.	(BAC - Earned) / (EAC - Actuals)
Total	This column displays the current total for each of the results over the life of the project.	N/A
Uid	This column displays the unique ID for the row.	N/A
Units	This column displays how the result is measured. For example, a unit of measurement might be dollars, or it might be tons.	N/A
Units Complete	This column displays the number of units completed.	N/A
Units To Do	This column displays the number of units that remain to be completed, which is available only if you selected the Units Complete progress technique.	N/A
User	This column displays the individual who is currently accessing the project.	N/A
User Character Fields [1-10]	This column displays the character fields that can be used for display in the view, or can be added as tags in the reports. Note: You must first run the required script to display User Character Fields [6-10]. For instructions on how to configure Cobra to use these additional fields, see Additional User Fields.	N/A
User Date Fields [1-10]	This column displays the date fields that can be used for display in the view, or can be added as tags in the reports. Note: You must first run the required script to display User Date Fields [6-10]. For instructions on how to configure Cobra to use these additional fields, see Additional User Fields.	N/A
User Numeric Fields [1-10]	This column displays the numeric fields that can be used for display in the view, or can be added as tags in the reports. Note: You must first run the required script to display User Numeric Fields [6-10]. For instructions on how to configure Cobra to use these additional fields, see Additional User Fields.	N/A
VAC	This column displays the Variance At Complete in dollars.	BAC - EAC
VAC %	This column displays the Variance At Complete percentage.	((BAC - EAC) / BAC) * 100
Variance	This column displays the Variance.	Budget - Actuals
Work Package	This column displays the work package ID.	N/A
Work Package Codes [1-20]	This column displays the work package codes assigned to the project.	N/A
Work Package Manager	This column displays the work package manager assigned to the project.	N/A